<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_supplier`;");
E_C("CREATE TABLE `ecs_supplier` (
  `supplier_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '申请入驻人id',
  `supplier_name` varchar(255) NOT NULL COMMENT '供货商名称',
  `rank_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '店铺等级',
  `type_id` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '店铺类型',
  `company_name` varchar(255) NOT NULL COMMENT '公司名称',
  `country` smallint(5) unsigned NOT NULL COMMENT '公司所在地(国家)',
  `province` smallint(5) unsigned NOT NULL COMMENT '公司所在地(省)',
  `city` smallint(5) unsigned NOT NULL COMMENT '公司所在地(市)',
  `district` smallint(5) unsigned NOT NULL COMMENT '公司所在地(县/区)',
  `address` varchar(255) NOT NULL DEFAULT '' COMMENT '公司详细地址',
  `tel` varchar(50) NOT NULL COMMENT '公司电话',
  `email` varchar(100) NOT NULL COMMENT '电子邮件',
  `guimo` varchar(255) NOT NULL COMMENT '公司规模',
  `company_type` varchar(50) NOT NULL COMMENT '公司类型',
  `bank` varchar(255) NOT NULL,
  `zhizhao` varchar(255) NOT NULL COMMENT '营业执照电子版',
  `contact` varchar(255) NOT NULL,
  `id_card` varchar(20) NOT NULL,
  `contact_back` varchar(255) NOT NULL,
  `contact_shop` varchar(255) NOT NULL,
  `contact_yunying` varchar(255) NOT NULL,
  `contact_shouhou` varchar(255) NOT NULL,
  `contact_caiwu` varchar(255) NOT NULL,
  `contact_jishu` varchar(255) NOT NULL,
  `system_fee` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `supplier_bond` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `supplier_rebate` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `supplier_rebate_paytime` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `supplier_remark` varchar(255) NOT NULL DEFAULT '',
  `nav_list` text NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '状态',
  `add_time` int(10) NOT NULL DEFAULT '0' COMMENT '申请时间',
  `applynum` smallint(1) unsigned NOT NULL DEFAULT '0' COMMENT '申请入驻步骤',
  `contacts_name` varchar(100) NOT NULL DEFAULT '' COMMENT '联系人',
  `contacts_phone` varchar(50) NOT NULL DEFAULT '' COMMENT '联系人电话',
  `business_licence_number` varchar(100) NOT NULL DEFAULT '' COMMENT '营业执照号',
  `business_sphere` text NOT NULL COMMENT '法定经营范围',
  `organization_code` varchar(100) NOT NULL COMMENT '组织机构代码',
  `organization_code_electronic` varchar(255) NOT NULL COMMENT '组织机构代码证电子版',
  `general_taxpayer` varchar(255) NOT NULL COMMENT '一般纳税人证明',
  `bank_account_name` varchar(100) NOT NULL COMMENT '银行开户名',
  `bank_account_number` varchar(100) NOT NULL COMMENT '公司开户行银行账号',
  `bank_name` varchar(100) NOT NULL COMMENT '开户银行支行名称',
  `bank_code` varchar(100) NOT NULL COMMENT '支行联行号',
  `settlement_bank_account_name` varchar(100) NOT NULL COMMENT '银行开户名(结算)',
  `settlement_bank_account_number` varchar(100) NOT NULL COMMENT '公司银行账号(结算)',
  `settlement_bank_name` varchar(100) NOT NULL COMMENT '开户银行支行名称(结算)',
  `settlement_bank_code` varchar(100) NOT NULL COMMENT '支行联行号(结算)',
  `tax_registration_certificate` varchar(100) NOT NULL COMMENT '税务登记证号',
  `taxpayer_id` varchar(100) NOT NULL COMMENT '纳税人识别号',
  `bank_licence_electronic` varchar(255) NOT NULL COMMENT '开户银行许可证电子版',
  `tax_registration_certificate_electronic` varchar(255) NOT NULL COMMENT '税务登记证号电子版',
  PRIMARY KEY (`supplier_id`),
  KEY `user_id` (`user_id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_supplier` values('1','13','秦皇岛商之翼','3','4','111','1','2','52','500','111','13812345678','1111@qq.ert','员工总数：XX人；注册资金：XX万元','私营企业','','13_20140918gbrbxk.jpg','','','','','','','','','800.00','10000.00','3','3','','','1','0','3','11','13812345678','22','22','222','13_20140918wbarya.jpg','13_20140918zlplcv.png','2222','22222222','222222222','2222222222','2222','22222222','222222222','2222222222','222','222222222222','13_20140918sklgoh.jpg','13_20140918qersyz.jpg');");
E_D("replace into `ecs_supplier` values('2','15','ecshop001','3','1','admin001','1','6','77','708','admin001','13333333333','admin001@qq.com','员工总数：XX人；注册资金：XX万元','私营企业','','15_20140918rraaws.png','','','','','','','','','800.00','10000.00','3','3','','','1','1412065444','3','admin001','13333333333','13333333333','admin001','admin001','15_20140918gjjasq.png','15_20140918wvgvgl.png','admin001','13333333333','admin001','13333333333','admin001','13333333333','admin001','13333333333','13333333333','13333333333','15_20140918acdxfq.png','15_20140918dzfmxi.png');");
E_D("replace into `ecs_supplier` values('3','16','秦皇岛商之翼科技','3','1','秦皇岛商之翼科技','1','2','52','500','ds','12320300287','wq@dwq.cm','员工总数：333人；注册资金：333万元','私营企业','','16_20140918gcmpoh.png','','','','','','','','','800.00','10000.00','3','3','','','1','1412065064','3','qw','13333333333','3212121','reeee','33232','16_20140918wwciut.jpg','16_20140918xhltaw.jpg','rww','12131122','bfdf','232121','weew','2322','few','42321','3213','3213','16_20140918zekqez.jpg','16_20140918lnhttd.png');");
E_D("replace into `ecs_supplier` values('4','17','ecshop002','5','5','admin002','1','2','52','501','admin002','13333333333','admin002@qq.com','员工总数：XX人；注册资金：XX万元','中外合资','','17_20140918jtkhae.png','','','','','','','','','800.00','10000.00','2','4','','','1','0','3','admin002','13333333333','13333333333','admin002','13333333333','17_20140918suoscm.png','17_20140918gsbncb.png','admin002','13333333333','admin002','13333333333','admin002','13333333333','admin002','13333333333','13333333333','13333333333','17_20140918trtptt.png','17_20140918pipeqo.png');");
E_D("replace into `ecs_supplier` values('5','18','秦皇岛天朝','3','10','秦皇岛天朝','1','5','67','634','ffw','13333333333','gwefw@q.cm','员工总数：555人；注册资金：55万元','外企','','18_20140918rxskqi.jpg','','','','','','','','','800.00','10000.00','3','3','','','1','0','3','wq','13333333333','1232','ddd','31232','18_20140918frtvjq.jpg','18_20140918vrwipr.jpg','wwew','1232','refrgr','3311','eeww','3213','gerg','32131','42','23232','18_20140918yqgrhf.jpg','18_20140918mwzceb.jpg');");
E_D("replace into `ecs_supplier` values('6','19','ecshop003','4','4','admin003','1','25','321','2706','admin003','13333333333','admin003@qq.com','员工总数：XX人；注册资金：XX万元','个体户','','19_20140918zdxlwl.png','','','','','','','','','800.00','10000.00','3','3','','','1','0','3','admin003','13333333333','13333333333','admin003','13333333333','19_20140918odahzb.png','19_20140918szdqxu.png','admin003','13333333333','admin003','13333333333','admin003','13333333333','admin003','13333333333','13333333333','13333333333','19_20140918ekmvxp.png','19_20140918fpktvw.png');");
E_D("replace into `ecs_supplier` values('7','20','秦皇岛ecshop','3','4','秦皇岛ecshop','1','2','52','503','dwfw','13333333333','qwdqw@fw.com','员工总数：444人；注册资金：555万元','外企','','20_20140918bxawys.jpg','','','','','','','','','800.00','10000.00','3','3','','','1','0','3','rqrq','13333333333','331','rqw','2112','20_20140918smpbed.jpg','20_20140918estyay.jpg','few','32','feww','412','were','323','efd','3231','313','3131','20_20140918jfskzr.jpg','20_20140918epxkmi.jpg');");
E_D("replace into `ecs_supplier` values('8','21','优衣库','4','1','22','1','2','52','500','1111','18712345678','222@qq.ert','员工总数：XX人；注册资金：XX万元','私营企业','','21_20140922jglnyc.jpg','','','','','','','','','200.00','100.00','20','2','通过','','1','1413792700','3','杨先生','13812345678','1122333','1122','22222','21_20140922tmvxqp.jpg','21_20140922xbsyju.jpg','wertyu','123456','ffbnbnb','346677','wertyu','123456','ffbnbnb','346677','222222222222','222222222222','21_20140922agnotb.jpg','21_20140922kcfigc.jpg');");
E_D("replace into `ecs_supplier` values('9','27','金铖IT教育','5','5','金城IT教育','1','15','211','1771','普阳街1068号','15843084303','906371075@qq.com','员工总数：100人；注册资金：200万元','私营企业','','27_20141020rrojgd.jpg','','','','','','','','','1000.00','1000.00','10','2','','','1','1413769739','3','张泽韧','15843084303','2121455846852487','IT教育','2121455846852487','27_20141020cprpyl.jpg','27_20141020suxtut.jpg','金铖IT教育','220155865478976578','建行支行','56546548989756','金铖IT教育','220155865478976578','建行支行','56546548989756','564632489324897','3987965465798756','27_20141020tzrasj.jpg','27_20141020asxbdg.jpg');");
E_D("replace into `ecs_supplier` values('10','28','金铖IT教育','5','4','金铖IT教育','1','2','52','500','普阳街1068号','15843084303','906371075@qq.com','员工总数：100人；注册资金：200万元','私营企业','','28_20141020tooxli.jpg','','','','','','','','','0.00','0.00','0','0','','','0','0','3','张泽韧','15843084303','221454789756','教育培训','54657579845','28_20141020cwqywf.jpg','28_20141020kyvcui.jpg','金铖IT教育','220155865478976578','建设银行','222222','金铖IT教育','220155865478976578','建设银行','222222','54655146887','87546328789','28_20141020bklfes.jpg','28_20141020wuiepc.jpg');");
E_D("replace into `ecs_supplier` values('11','29','','0','0','','0','0','0','0','','','','','','','','','','','','','','','','0.00','0.00','0','0','','','0','0','0','','','','','','','','','','','','','','','','','','','');");
E_D("replace into `ecs_supplier` values('12','30','','0','0','','0','0','0','0','','','','','','','','','','','','','','','','0.00','0.00','0','0','','','0','0','0','','','','','','','','','','','','','','','','','','','');");
E_D("replace into `ecs_supplier` values('13','31','e','5','1','e','1','2','52','502','e','15843084303','12343444@qq.com','员工总数：XX人；注册资金：XX万元','私营企业','','31_20141105cgqfme.jpg','','','','','','','','','1000.00','0.00','2','1','','','1','1415177831','3','e','13812345678','e','e','e','31_20141105izejzo.jpg','31_20141105ftuhap.jpg','e','e','e','e','e','e','e','e','e','e','31_20141105nydyai.jpg','31_20141105zscqsv.jpg');");
E_D("replace into `ecs_supplier` values('14','32','','0','0','','0','0','0','0','','','','','','','','','','','','','','','','0.00','0.00','0','0','','','0','0','0','','','','','','','','','','','','','','','','','','','');");
E_D("replace into `ecs_supplier` values('15','33','','0','0','','0','0','0','0','','','','','','','','','','','','','','','','0.00','0.00','0','0','','','0','0','0','','','','','','','','','','','','','','','','','','','');");
E_D("replace into `ecs_supplier` values('16','34','','0','0','','0','0','0','0','','','','','','','','','','','','','','','','0.00','0.00','0','0','','','0','0','0','','','','','','','','','','','','','','','','','','','');");
E_D("replace into `ecs_supplier` values('17','35','新世纪','3','3','新世纪超市','1','14','203','1706','三菱电机弗兰克','6925316','625399893@qq.com','员工总数：XX人；注册资金：XX万元','私营企业','','35_20141126hpncqc.jpg','','','','','','','','','300.00','50000.00','1','4','飞过海风格','','1','1416974385','3','阿萨德就','13812345678','453453227','自私的发射点发生的风格','44444444','35_20141126pjjqkz.jpg','35_20141126hvrxpc.jpg','年的风格集散地立刻反击','56468463518633','使得法国三顿饭','56546548989756','年的风格集散地立刻反击','56468463518633','使得法国三顿饭','56546548989756','4523453788','45245','35_20141126oxncnc.jpg','35_20141126dgjbao.jpg');");
E_D("replace into `ecs_supplier` values('18','39','dell官方旗舰店','5','2','DELL官方旗舰店','1','2','52','502','北京','01011111111','123456@qq.com','员工总数：100万人；注册资金：9000万元','外企','','39_20141205qzzleo.jpg','','','','','','','','','0.00','5000.00','3','2','','','1','1417771572','3','戴尔','13333333333','111111111','笔记本','111111111','39_20141205tashsq.jpg','39_20141205mvodca.jpg','dell','1111111111','dell','1111111','dell','111111111','dell','111111','111111','111111','39_20141205ryfhtd.jpg','39_20141205akszgg.jpg');");
E_D("replace into `ecs_supplier` values('19','42','1231313','5','9','淘宝旗舰店','1','2','52','500','DADASD','13312341234','123223@qq.com','员工总数：10人；注册资金：1000万元','私营企业','','42_20141205kdgpba.jpg','','','','','','','','','0.00','10000.00','3','2','','','1','1417771505','3','jjj','13333331234','12323213','123213','12321321321312','42_20141205oozkql.jpg','42_20141205ltsvbi.jpg','12312321','12312321','1232132','12321321','12312321','12312321','1232132','12321321','123123','123213213','42_20141205jpxdno.jpg','42_20141205jlxhht.jpg');");
E_D("replace into `ecs_supplier` values('20','43','韩都衣舍旗舰店','3','1','韩都衣舍旗舰店','1','10','145','1194','河北大街西段268号','03358988888','yy@qq.com','员工总数：200人；注册资金：3000万元','私营企业','','43_20141205pidzpc.png','','','','','','','','','0.00','0.00','255','2','','','1','1417771596','3','李佳','13909998976','yy','服装','7948759347','43_20141205yiymdl.png','43_20141205wfngdc.jpg','622134123478923479','622134123478923479','工商银行燕大支行','23423423553','532452523452','35234523452435','工商银行燕大支行','35234523452435','35234523452435','35234523452435','43_20141205puagde.jpg','43_20141205adfiwr.png');");
E_D("replace into `ecs_supplier` values('21','44','韩都衣舍时尚旗舰店','3','1','韩都衣舍时尚旗舰店','1','10','145','1194','河北大街西段68号','13898898746','yang@qq.com','员工总数：200人；注册资金：3000万元','私营企业','','44_20141205mujnnu.png','','','','','','','','','100000.00','0.00','2','3','','','1','1417772440','3','刘佳','13909998976','32334523452435','服装','244524352','44_20141205klivgt.png','44_20141205cjptkw.png','3452345133452345','5245243523452345','建设银行燕大支行','24352345234535','134523452345234','14352345234523','建设银行燕大支行','245245234524','5765757657576575','452452345234523','44_20141205mwkexi.png','44_20141205ooasaf.png');");
E_D("replace into `ecs_supplier` values('22','46','护肤世家雅诗兰黛官方旗舰店','3','4','护肤世家雅诗兰黛官方旗舰店','1','10','145','1194','奥林匹克大道68号','03358988888','5268@qq.com','员工总数：100人；注册资金：800万元','私营企业','','46_20141212eanlmd.jpg','','','','','','','','','6000.00','10000.00','2','4','予以通过','','1','1418366116','3','杨灵','13098988898','348794587','护肤用品','453454533','46_20141212nowjtf.jpg','46_20141212lotcna.jpg','622134123478923477','622134123478923477','工商银行秦皇岛支行','324234234','杨灵','622134123478923477','工商银行秦皇岛支行','324234234','34532534565645','341341453455','46_20141212unkrzl.jpg','46_20141212pbftlq.jpg');");

require("../../inc/footer.php");
?>